package com.hillinsight.entity;

/**
 * 对应MySQL中information_schema.COLUMNS表
 * Created by fangzheng on 2018/9/5.
 */
public class MySQLColumns {
    private String TABLE_CATALOG				;//表限定符
    private String TABLE_SCHEMA				    ;//表所有者
    private String TABLE_NAME					;//表名
    private String COLUMN_NAME					;//列名
    private String ORDINAL_POSITION			    ;//列标识号
    private String COLUMN_DEFAULT				;//列的默认值
    private String IS_NULLABLE					;//列的为空性如果列允许 NULL，那么该列返回 YES否则，返回 NO
    private String DATA_TYPE					;//系统提供的数据类型
    private String CHARACTER_MAXIMUM_LENGTH	    ;//以字符为单位的最大长度，适于二进制数据、字符数据，或者文本和图像数据否则，返回 NULL有关更多信息，请参见数据类型
    private String CHARACTER_OCTET_LENGTH		;//以字节为单位的最大长度，适于二进制数据、字符数据，或者文本和图像数据否则，返回 NULL
    private String NUMERIC_PRECISION			;//近似数字数据、精确数字数据、整型数据或货币数据的精度否则，返回 NULL
    private String NUMERIC_SCALE				;//近似数字数据、精确数字数据、整数数据或货币数据的小数位数否则，返回 NULL
    private String DATETIME_PRECISION			;//datetime 及 SQL-92 interval 数据类型的子类型代码对于其它数据类型，返回 NULL
    private String CHARACTER_SET_NAME			;//如果该列是字符数据或 text 数据类型，那么为字符集返回唯一的名称否则，返回 NULL
    private String COLLATION_NAME				;//如果列是字符数据或 text 数据类型，那么为排序次序返回唯一的名称否则，返回 NULL
    private String COLUMN_TYPE;
    private String COLUMN_KEY;
    private String EXTRA;
    private String PRIVILEGES;
    private String COLUMN_COMMENT;
    private String GENERATION_EXPRESSION;

    public String getTABLE_CATALOG() {
        return TABLE_CATALOG;
    }

    public void setTABLE_CATALOG(String TABLE_CATALOG) {
        this.TABLE_CATALOG = TABLE_CATALOG;
    }

    public String getTABLE_SCHEMA() {
        return TABLE_SCHEMA;
    }

    public void setTABLE_SCHEMA(String TABLE_SCHEMA) {
        this.TABLE_SCHEMA = TABLE_SCHEMA;
    }

    public String getTABLE_NAME() {
        return TABLE_NAME;
    }

    public void setTABLE_NAME(String TABLE_NAME) {
        this.TABLE_NAME = TABLE_NAME;
    }

    public String getCOLUMN_NAME() {
        return COLUMN_NAME;
    }

    public void setCOLUMN_NAME(String COLUMN_NAME) {
        this.COLUMN_NAME = COLUMN_NAME;
    }

    public String getORDINAL_POSITION() {
        return ORDINAL_POSITION;
    }

    public void setORDINAL_POSITION(String ORDINAL_POSITION) {
        this.ORDINAL_POSITION = ORDINAL_POSITION;
    }

    public String getCOLUMN_DEFAULT() {
        return COLUMN_DEFAULT;
    }

    public void setCOLUMN_DEFAULT(String COLUMN_DEFAULT) {
        this.COLUMN_DEFAULT = COLUMN_DEFAULT;
    }

    public String getIS_NULLABLE() {
        return IS_NULLABLE;
    }

    public void setIS_NULLABLE(String IS_NULLABLE) {
        this.IS_NULLABLE = IS_NULLABLE;
    }

    public String getDATA_TYPE() {
        return DATA_TYPE;
    }

    public void setDATA_TYPE(String DATA_TYPE) {
        this.DATA_TYPE = DATA_TYPE;
    }

    public String getCHARACTER_MAXIMUM_LENGTH() {
        return CHARACTER_MAXIMUM_LENGTH;
    }

    public void setCHARACTER_MAXIMUM_LENGTH(String CHARACTER_MAXIMUM_LENGTH) {
        this.CHARACTER_MAXIMUM_LENGTH = CHARACTER_MAXIMUM_LENGTH;
    }

    public String getCHARACTER_OCTET_LENGTH() {
        return CHARACTER_OCTET_LENGTH;
    }

    public void setCHARACTER_OCTET_LENGTH(String CHARACTER_OCTET_LENGTH) {
        this.CHARACTER_OCTET_LENGTH = CHARACTER_OCTET_LENGTH;
    }

    public String getNUMERIC_PRECISION() {
        return NUMERIC_PRECISION;
    }

    public void setNUMERIC_PRECISION(String NUMERIC_PRECISION) {
        this.NUMERIC_PRECISION = NUMERIC_PRECISION;
    }

    public String getNUMERIC_SCALE() {
        return NUMERIC_SCALE;
    }

    public void setNUMERIC_SCALE(String NUMERIC_SCALE) {
        this.NUMERIC_SCALE = NUMERIC_SCALE;
    }

    public String getDATETIME_PRECISION() {
        return DATETIME_PRECISION;
    }

    public void setDATETIME_PRECISION(String DATETIME_PRECISION) {
        this.DATETIME_PRECISION = DATETIME_PRECISION;
    }

    public String getCHARACTER_SET_NAME() {
        return CHARACTER_SET_NAME;
    }

    public void setCHARACTER_SET_NAME(String CHARACTER_SET_NAME) {
        this.CHARACTER_SET_NAME = CHARACTER_SET_NAME;
    }

    public String getCOLLATION_NAME() {
        return COLLATION_NAME;
    }

    public void setCOLLATION_NAME(String COLLATION_NAME) {
        this.COLLATION_NAME = COLLATION_NAME;
    }

    public String getCOLUMN_TYPE() {
        return COLUMN_TYPE;
    }

    public void setCOLUMN_TYPE(String COLUMN_TYPE) {
        this.COLUMN_TYPE = COLUMN_TYPE;
    }

    public String getCOLUMN_KEY() {
        return COLUMN_KEY;
    }

    public void setCOLUMN_KEY(String COLUMN_KEY) {
        this.COLUMN_KEY = COLUMN_KEY;
    }

    public String getEXTRA() {
        return EXTRA;
    }

    public void setEXTRA(String EXTRA) {
        this.EXTRA = EXTRA;
    }

    public String getPRIVILEGES() {
        return PRIVILEGES;
    }

    public void setPRIVILEGES(String PRIVILEGES) {
        this.PRIVILEGES = PRIVILEGES;
    }

    public String getCOLUMN_COMMENT() {
        return COLUMN_COMMENT;
    }

    public void setCOLUMN_COMMENT(String COLUMN_COMMENT) {
        this.COLUMN_COMMENT = COLUMN_COMMENT;
    }

    public String getGENERATION_EXPRESSION() {
        return GENERATION_EXPRESSION;
    }

    public void setGENERATION_EXPRESSION(String GENERATION_EXPRESSION) {
        this.GENERATION_EXPRESSION = GENERATION_EXPRESSION;
    }
}
